package com.ctgu.fastleader.dao;

import com.ctgu.fastleader.vo.Shelf;
import com.ctgu.fastleader.vo.ShelfKey;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ShelfMapper {
    int deleteByPrimaryKey(ShelfKey key);

    int insert(Shelf record);

    int insertSelective(Shelf record);

    Shelf selectByPrimaryKey(ShelfKey key);

    int updateByPrimaryKeySelective(Shelf record);

    int updateByPrimaryKey(Shelf record);

    List<String> findAllShelfIdByHouseId(Integer houseid);

    List<String> findAllShelfIdByHouseIdAndPianQu(@Param("houseid") Integer houseid,@Param("pianqu") String pianqu);

    List<String> findAllShelfIdByHouseIdAndPianQuAndHuojia(Integer houseid, String pianquhuojia);

    List<Shelf> findAllShelfByHouseIdAndPianQu(@Param("houseid") Integer houseid,@Param("pianqu") String pianqu);
}